It is important to notice that in both cases the whole database server will be restored to the specified point - in - time or logical log 以下这一点要重点注意,在两种情况下,整个数据库服务器都将被还原到指定的时间点或逻辑日志。
Whole - system backups are performed sequentially dbspace after dbspace and they can be restored without applying any logical logs 全系统备份是连续执行的(一个dbspace备份完成后接着另一个dbspace备份) ,并且可以不使用任何逻辑日志来还原它们。
Currently , four virtual log files are in use by the logical log . the logical log starts at the front of the first virtual log file and ends at virtual log 4 逻辑日志从第一个虚拟日志的前端开始,而且从未使用过虚拟日志4中超过逻辑文件末端的部分。
A cold restore has to be done if any of the critical dbspaces such as root dbspace , dbspaces containing the logical logs , or the physical log is down 如果任何关键dbspaces (比如根dbspace ,这些dbspace包含逻辑日志或物理日志)出错,则必须执行冷还原。
Backing up your logical logs is always a good idea and it is essential if you plan to do parallel backups or want to be able to perform point - in - time restores see 备份逻辑日志一直是一个好主意,如果计划执行并行备份或想要执行指定到某一点的还原(请参阅
It is essential that you ensure your logical logs will be backed up regularly if you plan to do parallel backups or want be able to perform point - in - time restores 如果计划执行并行备份或者希望能够执行指定到某一时间点的还原,则确保定期备份逻辑日志就非常重要。
If log records were never deleted from the transaction log , the logical log would grow until it filled all the available space on the disks holding the physical log files 如果从来没有从事务日志中删除日志记录,逻辑日志就会一直增长,直到填满容纳物理日志文件的磁盘上的所有可用空间。
However , in the case of a restore , you won t be able to get your data back because the logical logs are needed to reach a point of consistency for backups performed in parallel mode 不过,在进行这种情况的还原时,无法使数据还原,因为需要逻辑日志来达到并行模式下执行的备份的某个一致点。
To reduce the size of the logical log and , also , free disk space for reuse by the transaction log file , the inactive log must be truncated periodically 为了减小逻辑日志的大小,应定期截断事务日志。在sql server的最早版本中,截断日志意味着将进行数据库恢复或还原不再需要的日志记录物理删除。
File . though the first entry will match all objects dbspaces and logical logs , dbspace backups will be correctly assigned to management class ifx db because the matching is done from the bottom upwards and stops as soon as a match has been found . for dbspaces , it stops at entry 尽管第一个条目会匹配所有对象( dbspaces和logical logs ) ,但仍会将dbspace备份正确地分配给管理类ifx _ db ,因为匹配是从下往上进行的,一旦发现存在匹配,就会停下来,对于dbspaces备份,停在条目